{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,0,9,1],[8,3,9,4],[8,6,9,7],[3,0,3,1]]}
["AMCA Curvefit Function"]
["Air Performance"]
["Please fill the green colored cells."]
["Unit of Mesurement",null,"IP"]
[]
["Curvefit formula usage:"]
["GetCurvefitYValue(X-Value, X-Data_Range, Y-Data_Range)"]
[]
[null,null,null,"Perforamnce based on Static Pressure",null,null,"Perforamnce based on Airflow"]
["Test Data"]
[{"$f":"\"Airflow \" & IF($C$4=\"IP\",\"(cfm)\",\"(m3/sec)\")","v":"Airflow (cfm)"},{"$f":"\"Static Pressure \"&IF($C$4=\"IP\",\"(in. wg.)\",\"(Pa)\")","v":"Static Pressure (in. wg.)"},null,{"$f":"\"Airflow \" & IF($C$4=\"IP\",\"(cfm)\",\"(m3/sec)\")","v":"Airflow (cfm)"},{"$f":"\"Static Pressure \"&IF($C$4=\"IP\",\"(in. wg.)\",\"(Pa)\")","v":"Static Pressure (in. wg.)"},null,{"$f":"\"Airflow \" & IF($C$4=\"IP\",\"(cfm)\",\"(m3/sec)\")","v":"Airflow (cfm)"},{"$f":"\"Static Pressure \"&IF($C$4=\"IP\",\"(in. wg.)\",\"(Pa)\")","v":"Static Pressure (in. wg.)"}]
[739,0,null,{"$f":"IF(ISNUMBER(GetCurvefitYValue(E12,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E12,$B$12:$B$21,$A$12:$A$21),\"Below the knee\")","v":739},0,null,730,{"$f":"GetCurvefitYValue(G12,$A$12:$A$21,$B$12:$B$21)","v":1.3282990083098412E-2}]
[666,0.11,null,{"$f":"IF(ISTEXT(D12), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E13,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E13,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":672.504638671875},0.1,null,700,5.8125559240579605E-2]
[590,0.23,null,{"$f":"IF(ISTEXT(D13), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E14,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E14,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":656.8944091796875},0.125,null,670,0.10383911430835724]
[517,0.32,null,{"$f":"IF(ISTEXT(D14), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E15,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E15,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":641.7125244140625},0.15,null,640,0.15205055475234985]
[441,0.38,null,{"$f":"IF(ISTEXT(D15), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E16,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E16,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":610.295166015625},0.2,null,610,0.199705570936203]
[367,0.38,null,{"$f":"IF(ISTEXT(D16), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E17,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E17,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":593.4864501953125},0.22500000000000001,null,580,0.24394932389259338]
[294,0.37,null,{"$f":"IF(ISTEXT(D17), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E18,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E18,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":593.97265625},0.25,null,550,0.28282546997070313]
[221,0.42,null,{"$f":"IF(ISTEXT(D18), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E19,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E19,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":587.6204833984375},0.27500000000000002,null,520,0.31687813997268677]
[107,0.56000000000000005,null,{"$f":"IF(ISTEXT(D19), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E20,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E20,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":560.20623779296875},0.3,null,490,0.34660986065864563]
[0,0.7,null,{"$f":"IF(ISTEXT(D20), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E21,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E21,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":451.34796142578125},0.32500000000000001,null,460,0.3696669340133667]
[null,null,null,{"$f":"IF(ISTEXT(D21), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E22,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E22,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":233.05030822753906},0.35,null,430,0.38247635960578918]
[null,null,null,{"$f":"IF(ISTEXT(D22), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E23,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E23,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.375,null,400,0.38404643535614014]
[null,null,null,{"$f":"IF(ISTEXT(D23), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E24,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E24,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.4,null,370,0.38051292300224304]
[null,null,null,{"$f":"IF(ISTEXT(D24), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E25,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E25,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.42499999999999999,null,340,0.3737175464630127]
[null,null,null,{"$f":"IF(ISTEXT(D25), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E26,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E26,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.45,null,310,0.3694784939289093]
[null,null,null,{"$f":"IF(ISTEXT(D26), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E27,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E27,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.47499999999999998,null,280,0.37569218873977661]
[null,null,null,{"$f":"IF(ISTEXT(D27), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E28,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E28,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.5,null,250,0.39451837539672852]
[null,null,null,{"$f":"IF(ISTEXT(D28), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E29,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E29,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.52500000000000002,null,220,0.42097210884094238]
[null,null,null,{"$f":"IF(ISTEXT(D29), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E30,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E30,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.55000000000000004,null,190,0.45290964841842651]
[null,null,null,{"$f":"IF(ISTEXT(D30), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E31,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E31,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.57499999999999996,null,160,0.48926627635955811]
[null,null,null,{"$f":"IF(ISTEXT(D31), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E32,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E32,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.6,null,130,0.52864193916320801]
[null,null,null,{"$f":"IF(ISTEXT(D32), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E33,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E33,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.625,null,100,0.56890439987182617]
[null,null,null,{"$f":"IF(ISTEXT(D33), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E34,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E34,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.65,null,70,0.60746967792510986]
[null,null,null,{"$f":"IF(ISTEXT(D34), \"Below the knee\", IF(ISNUMBER(GetCurvefitYValue(E35,$B$12:$B$21,$A$12:$A$21)),GetCurvefitYValue(E35,$B$12:$B$21,$A$12:$A$21),\"Below the knee\"))","v":"Below the knee"},0.67500000000000004,null,0,0.69999998807907104]